VBA Primer

Course Plan

Week 1

Online session 1

This is really just to get people started on using Visual Basic for Applications

By the end of the workshop you should feel confident writing basic computer programs in VBA

Go to Introducing Excel VBA

Zoom session 1

This session is interactive and to allow students to get specific feedback on their code and help where they are stuck.

Week 2

Online session 2

Develop solutions to some actuarial type problems in VBA

The rest of this workshop will cover the areas of solving equations using Newton Rhapson and solving differential equations using the Rung-Kutta method. We will also look at numerical integration techniques and Monte Carlo methods

The notes can be found here: Mathematical Preliminaries

Zoom session 2

Interactive session allowing students to discuss problems and solutions in their code